home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Business Master (3rd Edition)
/
The Business Master (3rd Edition).iso
/
files
/
comphelp
/
begin6pk
/
3dbf
< prev
next >
Wrap
Text File
|
1993-03-21
|
5KB
|
196 lines
3DBF
░░░░░░░░░░░░░░░░░░░░░░░
░ CREATING A DATABASE ░
░░░░░░░░░░░░░░░░░░░░░░░
Notice there are four highlighted-columns that
are to be filled in, they are:
Field Name Type Width Dec
══════════════════════════════════════════
█████████████ █████████ ████ ████
√√√ WHAT THESE COLUMNS MEAN
Field_Names:
Each field needs a name.
The name could have up to 10 characters.
You can use the Underscore (_) to separate
words, but not spaces.
An example of using Underscore to separate words.
LAST_NAME ...This is OK.
LAST NAME ...This is not acceptable.
√√√ TYPE
There are five types of information that can be stored
in this Field. To make a selection press the SPACEBAR.
√√√ CHARACTER
Letters, punctuation marks, numbers that are
going to be printed, but are NOT going to be used in
mathematical calculations.
√√√ NUMERIC
Numbers that will be used in mathematical calculations,
such as dollar amounts.
√√√ LOGICAL
For true/false or yes/no data.
√√√ DATE
Dates only--such as 10/10/92.
√√√ MEMO
Here you can store varying amounts of text
or each record. For example some notes about
the person in the record.
√√√ WIDTH
Used for setting the least number of spaces
you will need for letters and numbers you plan to put in
a field.
√√√ Logical
Date, and Memo are automatically assigned a width.
√√√ DEC
If you are defining a NUMERIC field you must indicate
the the number of spaces. For monetary figures, you
would type in 2 for dollar and cents.
=============
-1-
░░░░░░░░░░░░░░░░░░░░░░░░
░ TYPING IN THE FIELDS ░
░░░░░░░░░░░░░░░░░░░░░░░░
Field Name Type Width Dec
========================================
======
1. LAST_NAME CHARACTER 12 ---
2. FIRST_NAME CHARACTER 10 ---
3. STREET CHARACTER 15 ---
4. CITY CHARACTER 10 ---
5. STATE CHARACTER 2 ---
6. ZIP_CODE CHARACTER 5 ---
7. DUES_PAID NUMERIC 6 2
√√√ HOW TO SAVE THE DATABASE
Press and hold down the Control <Ctrl> key...then press
the <END> key. Your database is saved with the name MEMBERS.
PRESS ENTER TO CONFIRM.
Screen now asks "Input Data Records Now? Press Y for Yes.
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░THE DATABASE STRUCTURE APPEARS ON THE SCREEN░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
LAST_Name ██████████████
FIRST_NAME ███████████
Street ███████████████
CITY ███████████
STATE ███
ZIP_CODE ███████
DUES_PAID █████████
√√√ ADDING DATA (MEMBERS NAMES) TO THE DATABASE
Type the following five MEMBERS into the database (above)
in the spaces provided. After each entry, press the <Enter>
key to move to the next column of the database.
LAST_NAME FIRST_NAME STREET CITY STATE ZIP Dues_Paid
-----------------------------------------------------------------
CHAMBERS NEIL 386 JACKSON ST MIAMI FL 33310 25.00
JENSEN HOWARD 4654 ONEIDA ST PITTSFORD NY 14534 25.00
KANTON JANE 90 FIRST ROAD NEW YORK NY 10011 15.00
MICHAELS MARY 13 DOBBY LANE CHANDLER AZ 85225 25.00
SMITH FRANK 55 COAST ROAD EAGLE CRK OR 97022 10.00
SEE NEXT PAGE FOR SAMPLE DATABASE
-2-
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░ SAMPLE ░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░ LAST_NAME CHAMBERS ░
░ FIRST_NAME NEIL ░
░ STREET 386 JACKSON ST ░
░ CITY MIAMI ░
░ STATE FL ░
░ ZIP 33310 ░
░ DUES PAID 25.00 ░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
*** END OF CHAPTER ***
Press <ESC> key to return to Menu.
Select "OPENING A DATATBASE", then press <Enter> key.
-10-